Employee Data and Analysis
American Trans Air
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
Traffic Indicies  
Stage Length in Miles (for SLA purposes)             1,213            1,199            1,251            1,046               963            1,061            1,208            1,206            1,232            1,208            1,233            1,574            1,651
Seats Per Departure (for SDA purposes)               242               236               230               220               218               229               231               217               211               204               206               193               199
Price Per Gallon of Fuel  $          0.64  $          0.76  $          0.74  $          0.60  $          0.71  $          1.00  $          0.97  $          0.86  $          1.00  $          1.31  $          1.81  $          2.12  $          2.12
Airborne Hours / Block Hours 87% 86% 87% 87% 86% 85% 86% 87% 66% 87% 87% 90% 43%
Outsourcing Indicies  
Maintenance $'s Outsourced 29.9% 28.5% 28.2% 30.3% 25.2% 21.2% 19.1% 10.8% 6.3% 7.1% 14.8% 37.4% 41.0%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 19.3% 13.1% 12.7% 12.5% 12.7% 11.8% 10.3% 11.0% 11.5% 35.0% 58.8% 15.2% 13.1%
Transport Related Expense (000)  $              6  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Productivity Measures (unadjusted)  
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)                 -                33.1              29.1              19.2              19.5              38.6              37.4              42.8              40.4              42.3              38.6              30.8                 -  
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)                 -                50.3              40.4         9,675.7                 -              154.3              44.7              42.3              47.4              54.8              49.8              36.4                 -  
Maintenance                 -                17.9              18.7              19.1              18.1              18.4              20.1              15.2              23.7              27.2              56.7              70.7                 -  
Passenger, Cargo and Aircraft Handling                 -                12.1               9.4              12.1              10.8               5.7               6.2               9.4               8.0              10.5              17.0              15.6                 -  
Other                 -                26.9              13.5              14.0              16.2              18.0              20.1              21.2              31.8              52.4              37.8              28.3                 -  
Total                 -                 2.6               2.2               2.4               2.4               2.2               2.3               2.7               2.9               3.6               4.1               3.4                 -  
ASMs Per Employee (000)
Pilots & Co-Pilots                 -         19,020.4       16,522.5         6,214.5         6,204.8       16,460.6       17,834.1       20,583.3       18,999.7       19,368.2       17,628.3       13,692.0                 -  
Flight Attendants                 -         12,254.1         9,960.4   2,276,567.2                 -         36,146.5       10,791.8       10,142.6       11,296.6       12,993.1       11,874.0         9,076.9                 -  
Maintenance                 -         20,538.5       21,279.0       19,739.0       18,318.8       19,740.5       22,398.6       15,766.3       23,849.8       26,332.8       55,797.9       68,114.7                 -  
Passenger, Cargo and Aircraft Handling                 -         13,858.6       10,711.6       12,543.1       10,974.3         6,160.9         6,909.0         9,791.1         8,047.3       10,188.8       16,753.6       15,038.3                 -  
Other                 -         30,953.0       15,302.3       14,531.3       16,455.2       19,359.5       22,367.3       22,005.5       31,974.4       50,794.0       37,198.6       27,291.8                 -  
Total                 -           2,951.2         2,495.5         2,531.4         2,463.9         2,329.7         2,594.4         2,774.2         2,941.6         3,500.7         4,049.3         3,303.0                 -  
Employees Per Aircraft
Pilots & Co-Pilots (Crews)                 -                 6.4               7.4              12.8              14.0               7.5               7.8               6.8               7.9               8.1               8.4              12.4                 -  
Flight Attendants (Crews)                 -                 4.2               5.3               0.0                 -                 1.9               6.6               6.8               6.7               6.2               6.5              10.5                 -  
Maintenance (Inhouse)                 -                11.9              11.5              12.9              15.1              15.8              14.6              19.1              13.4              12.5               5.7               5.4                 -  
Passenger, Cargo and Aircraft Handling (Inhouse)                 -                17.6              22.8              20.2              25.3              50.5              47.4              30.7              39.7              32.4              19.1              24.4                 -  
Other (Inhouse)                 -                 7.9              16.0              17.5              16.9              16.1              14.6              13.7              10.0               6.5               8.6              13.4                 -  
Total                 -                82.6              98.0            100.3            112.6            133.5            126.3            108.4            108.5              94.2              78.9            111.1                 -  
Passengers Per Employee
Pilots & Co-Pilots                 -              7,670            6,887            2,796            2,979            7,612            8,702          10,602            9,393            9,664            7,479            4,862                 -  
Flight Attendants                 -              4,941            4,152      1,024,107                 -            16,715            5,266            5,224            5,585            6,483            5,037            3,223                 -  
Maintenance                 -              8,282            8,870            8,880            8,794            9,128          10,929            8,121          11,791          13,140          23,672          24,189                 -  
Passenger, Cargo and Aircraft Handling                 -              5,588            4,465            5,642            5,268            2,849            3,371            5,043            3,978            5,084            7,108            5,340                 -  
Other                 -            12,482            6,378            6,537            7,899            8,952          10,914          11,334          15,807          25,345          15,781            9,692                 -  
Total                 -              1,190            1,040            1,139            1,183            1,077            1,266            1,429            1,454            1,747            1,718            1,173                 -  
Productivity Measures Revenue  
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $             -    $        558.8  $        482.7  $        231.9  $        294.1  $        842.4  $        866.1  $        963.7  $        938.1  $        952.7  $        837.7  $        651.7  $             -  
Flight Attendants  $             -    $        360.0  $        291.0  $    84,939.4  $             -    $     1,849.8  $        524.1  $        474.9  $        557.7  $        639.1  $        564.3  $        432.0  $             -  
Maintenance  $             -    $        603.4  $        621.6  $        736.5  $        868.4  $     1,010.2  $     1,087.7  $        738.2  $     1,177.5  $     1,295.3  $     2,651.5  $     3,241.9  $             -  
Passenger, Cargo and Aircraft Handling  $             -    $        407.1  $        312.9  $        468.0  $        520.2  $        315.3  $        335.5  $        458.4  $        397.3  $        501.2  $        796.1  $        715.7  $             -  
Other  $             -    $        909.3  $        447.0  $        542.2  $        780.0  $        990.7  $     1,086.2  $     1,030.3  $     1,578.7  $     2,498.5  $     1,767.7  $     1,298.9  $             -  
Total  $             -    $          86.7  $          72.9  $          94.4  $        116.8  $        119.2  $        126.0  $        129.9  $        145.2  $        172.2  $        192.4  $        157.2  $             -  
Salary and Benefits  
Average Salary
Management and All Other  $             -    $      22,135  $      20,068  $      21,670  $      25,010  $      47,022  $      57,712  $      62,738  $      61,925  $      96,257  $      73,133  $      43,562  $             -  
Pilots & Co-Pilots  $             -    $      54,537  $      56,924  $      24,156  $      26,921  $      72,001  $      79,674  $     107,563  $     110,444  $     121,459  $     116,100  $     105,994  $             -  
Flight Attendants  $             -    $      23,720  $      20,343  $  4,782,528  $             -    $      90,512  $      29,688  $      22,393  $      27,386  $      30,881  $      34,197  $      35,237  $             -  
Maintenance  $             -    $      54,898  $      57,353  $      54,821  $      58,226  $      64,470  $      80,253  $      48,967  $      63,628  $      65,495  $     157,784  $     172,822  $             -  
Passenger, Cargo and Aircraft Handling  $             -    $      11,353  $        8,600  $      12,474  $      13,002  $        9,320  $      12,659  $      15,897  $      12,004  $      15,204  $      24,880  $      33,399  $             -  
Total  $             -    $      29,956  $      27,404  $      30,372  $      33,092  $      33,109  $      39,863  $      42,050  $      42,405  $      51,260  $      64,138  $      59,630  $             -  
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $             -    $        5,404  $        5,353  $        2,461  $        2,948  $        4,972  $        6,497  $        4,244  $             -    $             -    $             -    $      18,542  $             -  
All Others  $             -    $        2,219  $        1,706  $        2,965  $        3,983  $        3,481  $        5,095  $        6,566  $             -    $             -    $             -    $        8,924  $             -  
Total  $             -    $        2,713  $        2,257  $        2,760  $        3,572  $        3,692  $        5,299  $        6,253  $        7,595  $      10,482  $      12,840  $      11,244  $             -  
Personnel
Pilots & Co-Pilots  $             -    $      20,097  $      19,098  $        7,459  $        8,116  $      25,812  $      41,389  $      56,301  $      53,791  $      48,403  $      55,182  $      51,380  $             -  
Flight Attendents  $             -    $      20,451  $      17,218  $  4,168,187  $             -    $      86,591  $      13,802  $        2,731  $        2,299  $        2,046  $        2,902  $      11,140  $             -  
Payroll Taxes
Pilots & Co-Pilots  $             -    $        4,963  $        4,897  $        2,088  $        2,412  $        6,251  $        7,184  $        5,475  $             -    $             -    $             -    $        8,786  $             -  
All Others  $             -    $        2,009  $        1,646  $        2,553  $        2,595  $        2,007  $        2,406  $        2,769  $             -    $             -    $             -    $        3,931  $             -  
Raw Data  
Number of Months 12 12 12 12 12 12 12 12 12 12 12 12 12
Number of Days 365 366 365 365 365 366 365 365 365 366 365 365 365
P10- Employee Count Data  
Sum of General Management                 676               431               471               544                43                42                40                27                26                17                14  
Sum of Pilots and Co-Pilots                 690               765               884               937               723               745               783               998            1,008               689               542  
Sum of Other Flight Personnel                   -                   -              1,314            1,357               252               153                68                74                62                58                50  
Sum of Passenger and General Services              1,071            1,269                  6                 -                 444            1,484            1,727            1,803            1,595            1,109               893  
Sum of Maintenance                 639               594               692               777               813               715            1,111               854               787               236               119  
Sum of AC Handling 1                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -    
Sum of Aircraft Handling                 916            1,152            1,063            1,267               496               469               147               388               316               286               265  
Sum of Aircraft Control                   -                   -                   -                   -                  64                54                42                52                45                32                20  
Sum of Passenger Handling                   -                   -                   -                   -              1,748            1,521            1,576            1,616            1,240               364               236  
Sum of Cargo Handling                  31                28                26                30               297               274                24               475               433               104                18  
Sum of Trainees and Instructors                  34                30                28                19                55                63                33                61                21                21                15  
Sum of Stats                   -                   -                    1                 -                 176               155                61               199               145               105                93  
Sum of Traffic Solicitors                  23                27                23                26                68                52                26                29                20                15                14  
Sum of Other                 367               769               888               820               530               446               676               348               222               213               175  
Sum of Transport Related                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -                   -    
Sum of Total            4,447            5,065            5,396            5,777            6,889            6,173            6,314            6,924            5,920            3,252            2,454
P6- Objective Grouping Operating Expense Data  
Sum of Salaries-General Management Personnel (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $        4,575  $        1,351
Sum of Salaries-Flight Personnel (000)  $      37,648  $      63,035  $      69,362  $      81,790  $      93,827  $     110,389  $     115,604  $     130,210  $     167,773  $     179,216  $     124,651  $      94,215  $      44,230
Sum of Salaries-Maintenance Labor (000)  $      32,243  $      35,080  $      34,067  $      37,936  $      45,241  $      52,414  $      57,381  $      54,403  $      54,338  $      51,545  $      37,237  $      20,566  $        8,648
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)  $        6,848  $      10,751  $      10,148  $      13,584  $      16,863  $      24,279  $      29,345  $      28,440  $      30,383  $      30,925  $      19,556  $      18,002  $        7,793
Sum of Salaries-Other Personnel (000)  $      38,912  $      24,348  $      25,225  $      30,576  $      35,239  $      41,003  $      43,746  $      52,449  $      41,118  $      41,776  $      27,132  $        8,973  $        5,762
Sum of Salaries-Total (000)  $     115,651  $     133,214  $     138,802  $     163,886  $     191,170  $     228,085  $     246,075  $     265,501  $     293,612  $     303,462  $     208,576  $     146,331  $      67,784
Sum of Related Fringe Benefits-Personnel Expense (000)  $      31,409  $      35,770  $      36,459  $      41,405  $      48,622  $      63,613  $      57,650  $      52,629  $      61,809  $      55,055  $      44,439  $      40,365  $      19,813
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $        8,380  $      12,066  $      11,433  $      14,891  $      20,635  $      25,436  $      32,712  $      39,482  $      52,590  $      62,051  $      41,757  $      27,593  $      12,304
Sum of Related Fringe Benefits-Payroll Taxes (000)  $        9,232  $      10,972  $      10,823  $      12,754  $      14,570  $      17,964  $      19,145  $      19,786  $      22,378  $      24,284  $      18,605  $      12,521  $        6,589
Sum of Related Fringe Benefits-Total (000)  $      49,020  $      58,809  $      58,716  $      69,050  $      83,827  $     107,012  $     109,507  $     111,896  $     136,777  $     141,390  $     104,800  $      80,479  $      38,706
Sum of Total Salaries And Related Fringe Benefits (000)  $     164,671  $     192,023  $     197,518  $     232,936  $     274,998  $     335,097  $     355,582  $     377,397  $     430,389  $     444,852  $     313,376  $     226,810  $     106,490
Sum of Services Purchased-Advertising And Other Promotions (000)  $        7,209  $        8,146  $        9,652  $      13,718  $      13,980  $      17,600  $      30,169  $      37,694  $      36,255  $      32,008  $        8,960  $        3,000  $        1,357
Sum of Services Purchased-Communication (000)  $        7,025  $        9,230  $        6,785  $        7,572  $        9,264  $        9,694  $        8,797  $        9,392  $      10,715  $        9,260  $        6,768  $        3,876  $        1,427
Sum of Services Purchased-Insurance (000)  $        6,692  $      12,244  $      10,652  $        8,961  $        7,882  $        6,799  $      11,523  $      30,117  $      26,672  $      24,174  $      14,489  $      10,346  $        4,246
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $      29,801  $      29,829  $      27,942  $      32,547  $      29,675  $      34,667  $      25,882  $      12,438  $        6,165  $        8,972  $      13,939  $      22,207  $      12,340
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $      23,161  $      24,566  $      24,290  $      26,787  $      29,608  $      29,156  $      27,435  $      19,571  $      21,810  $      25,579  $      26,507  $      21,523  $        9,006
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             76  $             36
Sum of Services Purchased-Other Services (000)  $     104,113  $      77,949  $      73,977  $      82,445  $      95,002  $     104,827  $     102,274  $     119,440  $     128,257  $     565,873  $     689,040  $      82,835  $      34,742
Sum of Services Purchased-Total (000)  $     178,001  $     161,964  $     153,299  $     172,030  $     183,573  $     202,743  $     206,079  $     228,651  $     229,875  $     665,866  $     725,222  $     143,862  $      63,080
Sum of Transport Related Expense (000) 6.09 0 0 0 0 0 0 0 0 0 0 0 0
Sum of Total Operating Expense (000)  $     668,051  $     755,948  $     736,121  $     798,604  $     915,023  $  1,162,756  $  1,238,799  $  1,290,744  $  1,384,242  $  1,971,474  $  1,492,644  $     783,018  $     378,736
T1 & T2- Traffic Data  
Sum of RPMs 9.02E+09 9.08E+09 8.98E+09 9.61E+09 1.05E+10 1.17E+10 1.15E+10 1.23E+10 1.41E+10 1.45E+10 8.72E+09 5.66E+09 6.14E+09
Sum of ASMs 1.28E+10 1.31E+10 1.26E+10 1.37E+10 1.42E+10 1.60E+10 1.60E+10 1.75E+10 2.04E+10 2.07E+10 1.32E+10 8.11E+09 8.49E+09
Sum of Miles 5.29E+07 5.56E+07 5.48E+07 6.21E+07 6.52E+07 7.01E+07 6.94E+07 8.08E+07 9.66E+07 1.01E+08 6.39E+07 4.19E+07 4.26E+07
Sum of Depts          43,587          46,370          43,833          59,397          67,665          66,063          57,459          67,016          78,463          83,912          51,807          26,645          25,802
Sum of Airborne Hours        112,185        118,199        116,643        137,754        145,029        152,788        148,399        176,502        160,805        222,578        140,524          91,042          43,020
Sum of Block Hours        128,611        137,003        133,629        158,419        168,536        179,488        172,384        202,402        243,074        256,546        160,624        100,997        100,430
Sum of AC Days          17,557          19,702          18,872          19,634          18,732          18,892          17,842          21,253          23,283          22,991          15,037            8,060            4,638
Sum of Gallons 2.02E+08 2.13E+08 2.07E+08 2.28E+08 2.38E+08 2.72E+08 2.54E+08 2.32E+08 2.68E+08 2.71E+08 1.77E+08 1.13E+08 5.37E+07
Sum of Passengers      4,594,014      5,292,283      5,268,622      6,144,641      6,832,847      7,421,281      7,814,501      9,022,170    10,069,332    10,340,914      5,586,569      2,878,525      3,064,687
P12- Profit and Loss Statement  
Sum of Pax Rev (000) -3.55E+05 -3.86E+05 -3.69E+05 -5.10E+05 -6.75E+05 -8.21E+05 -7.78E+05 -8.20E+05 -1.01E+06 -1.02E+06 -6.26E+05 -3.86E+05 -1.72E+05
Sum of Charter Pax (000)  $    (301,597)  $    (309,292)  $    (358,264)  $    (343,032)  $    (302,792)  $    (351,191)  $    (336,076)  $    (291,634)  $    (359,281)  $    (351,733)  $    (403,202)  $    (347,008)  $    (160,712)
Sum of Transport Related Rev (000)  $     (18,256)  $             -    $             -    $       (2,337)  $       (6,540)  $     (14,753)  $             -    $          (347)  $             -    $             -    $          (411)  $       (2,257)  $       (1,151)
Sum of Cargo Rev (000)  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Total Rev (000) -6.82E+05 -7.16E+05 -7.46E+05 -8.79E+05 -1.00E+06 -1.18E+06 -1.15E+06 -1.15E+06 -1.40E+06 -1.41E+06 -1.05E+06 -7.52E+05 -3.41E+05
P52- Functional Grouping Operating Expense Data  
Sum of Pilots And Copilots (000)  $      23,583  $      28,811  $      33,382  $      41,115  $      47,911  $      54,690  $      57,915  $      81,747  $     109,585  $     122,396  $      81,681  $      58,444  $      27,677
Sum of Other Flight Personnel (000)  $        7,660  $        8,819  $      10,164  $      11,980  $      13,846  $      15,512  $      13,632  $        9,790  $        8,811  $        7,565  $        5,046  $        4,305  $        2,192
Sum of Trainees And Instructors (000)  $           883  $        2,410  $           952  $        1,330  $        1,399  $        1,639  $        2,049  $        2,393  $        2,600  $        1,942  $        1,177  $        1,145  $           557
Sum of Personnel Expenses (000)  $      11,778  $      13,867  $      14,610  $      16,396  $      18,618  $      25,166  $      37,167  $      47,912  $      57,664  $      51,791  $      41,221  $      30,417  $      18,438
Sum of Employee Benefits And Pensions (000)  $        2,344  $        3,729  $        4,095  $        5,409  $        6,763  $        4,848  $        5,834  $        3,611  $             -    $             -    $             -    $      10,977  $        5,120
Sum of Taxes-Payroll (000)  $        2,653  $        3,425  $        3,746  $        4,589  $        5,532  $        6,094  $        6,451  $        4,659  $             -    $             -    $             -    $        5,201  $        2,463
Sum of Total Flight Equipment Maintenance (Memo) (000)  $      99,725  $     104,539  $      99,094  $     107,319  $     117,866  $     163,592  $     135,718  $     115,530  $      98,524  $     126,420  $      94,083  $      59,382  $      30,120
Sum of Flying Operations-Aircraft Fuels (000)  $     129,643  $     161,201  $     153,592  $     137,401  $     169,560  $     271,403  $     246,892  $     200,418  $     267,163  $     356,650  $     319,908  $     239,581  $     113,677